import openpyxl

excelRead = openpyxl.load_workbook('C:\Download\Result_30.xlsx')
# 读取sheet
sheetRead = excelRead['Result 1']

# 读取uuid, connectorId, stationName列表
col1 = [item.value for item in list(sheetRead.columns)[0]]
col2 = [item.value for item in list(sheetRead.columns)[1]]
col3 = [item.value for item in list(sheetRead.columns)[2]]
uuids = col1[1:]
connectorIds = col2[1:]
stationNames = col3[1:]

# 写入
excelWrite = openpyxl.Workbook()
sheetWrite = excelWrite.active

sheetWrite['A1'] = '二维码内容'
for i in range(len(uuids)):
    sheetWrite[f'A{i + 2}'] = 'https://cdt.evergrande.com/QRCodeScaner.html?pileUuid=' + uuids[i]

sheetWrite['B1'] = '设备编号'
for i in range(len(uuids)):
    sheetWrite[f'B{i + 2}'] = connectorIds[i]

sheetWrite['C1'] = '场站名称'
for i in range(len(uuids)):
    sheetWrite[f'C{i + 2}'] = stationNames[i]


excelWrite.save('C:\Download\dataSheetSample.xlsx')